package com.central.apps.dao.MaterialInventory;

import org.apache.ibatis.annotations.*;

import java.util.List;
import java.util.Map;

@Mapper
public interface outWarehouseDao {
    @Select("SELECT invusenum FROM gq_return WHERE id = #{id}")
    String outinvusenumById (String id);
    @Delete("delete from gq_returnline where invusenum = #{returnnum}")
    void delreturnnum (String returnnum);
    @Select("SELECT itemnum,itemdesc,specmodel,quantity,grantqty,actualdate,unit,wonum,binnum,lotnum,locations from gq_invuseline where invusenum = #{invusenum}")
    List<Map<String, Object>> getinvuselineHandler(@Param("invusenum") String invusenum);
    @Insert("INSERT INTO gq_returnline (invusenum,itemnum,itemdesc,specmodel,quantity,bunber,actualdate,unit,wonum,binnum,tolot,locations) VALUES (#{map.invusenum},#{map.itemnum},#{map.itemdesc},#{map.specmodel},#{map.quantity},#{map.bunber},#{map.actualdate},#{map.unit},#{map.wonum},#{map.binnum},#{map.tolot},#{map.locations})")
    int insert(@Param("map") Map<String, Object> map);
}
